/*
 *  FxBasicInfo.h
 *  StrategyInspector
 *
 *  Created by jiro on 12/08/11.
 *  Copyright 2012 jiro music. All rights reserved.
 *
 */

#pragma once 

#import "DbTableEntry.h"
#import "DbConstants.h"
#import "BrokerageFirm.h"

class FxBasicInfo : public DbTableEntry
{
public:

	static NSString* tableName();
	static NSString* queryCreateTable();
	static NSString* queryInsertInitialValues();
	static NSString* querySelectAll( const std::vector< ClauseNode >& clauses );
	static NSString* querySelect( const std::vector< FieldNode >& fieldNodes, const std::vector< ClauseNode >& clauses );

	NSString* queryInsert() const;
	NSString* queryInsertValue() const;

	FxBasicInfo();
	FxBasicInfo( int brokerageFirmIndex, NSString* currencyCode, NSString* targetCurrencyCode, double spread, double charge );


public:

	int brokerageFirmIndex;

	NSString* currencyCode;

	NSString* targetCurrencyCode;

	double spread;
	
	double charge;

};
